A horizontal (row) lookup that searches the top row of the range indicated in the argument compare-range looking for the search value, lookup value. If the search condition is met (as determined by the method argument), the row number of the found cell is offset by the amount specified in index. The function then returns the contents of that cell. If the search condition is not met, an error is returned.
Format: HLOOKUP (lookup-value, compare-range, index {,method})
Arguments:
ΓÇó lookup-value: A text or numeric expression.
ΓÇó compare-range: A cell range of 1 or more rows.
ΓÇó offset: A numeric expression.
ΓÇó method: Optional. When the values in the first row are increasing from left to right, use 1 to locate the largest value which is less than or equal to the lookup value. When the values in the first row are decreasing from left to right, use -1 to locate the smallest value which is greater than or equal to the lookup value. Use 0 to return the exact match to the lookup value. If the method is not specified, 1 will be used.
